package com.hxci.dao;

import com.hxci.pojo.student;
import org.apache.ibatis.annotations.Mapper;
import java.util.List;
import java.util.Map;
import org.apache.ibatis.annotations.Param;

@Mapper
public interface StudentMapper {
    List<student> getStudentData(Map<String, Object> params);
    List<String> getAllClassNames();
    List<String> getAllTitles();
    int getTotalStudentCount();
    int getTotalStudentCountByCondition(Map<String, Object> params);
    int updateScoreByNameAndTitle(Map<String, Object> params);
    List<student> getSubmissionsByName(String name);
    List<Map<String, Object>> getClassSubmissionStats(Map<String, Object> params);
    List<student> getUnsubmittedStudents(Map<String, Object> params);
    String getTitleByOffset(@Param("offset") int offset);
    List<student> getSubmissionsByNameAndTitle(@Param("name") String name, @Param("title") String title);
}